package top.leyi.mapper;

import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Select;
import top.leyi.entity.Visit;

import java.util.List;

public interface VisitMapper {

    @Insert("INSERT INTO visit(dayTime, hourTime, visitors) values (#{dayTime}, #{hourTime}, #{visitors})")
    public void addVisitor(Visit visit);



    @Select("SELECT * FROM visit  WHERE dayTime = #{value} ORDER by hourTime")
    public List<Visit> queryVisitor(String dayTime);



}
